home *** CD-ROM | disk | FTP | other *** search
/ Amiga Plus 2002 #3 / Amiga Plus CD - 2002 - No. 03.iso / AmigaPlus / AmigaOS / Aplus_Dev / AP-Website / news / admin / index.php < prev    next >
Encoding:
PHP Script  |  2002-10-28  |  6.9 KB  |  219 lines
  1. <html>
  2. <head>
  3. <title>AmigaPlus News Admin</title>
  4. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  5. </head>
  6.  
  7. <body bgcolor="#66CCFF" text="#000000">
  8. <?php
  9.     
  10.     $server = "db04.puretec.de";
  11.     $db = "db24905524";
  12.     $login = "p343302";
  13.     $pass = "90f42902";
  14.     
  15.     $dbwww = mysql_connect($server,$login,$pass);
  16.     mysql_select_db($db,$dbwww);
  17.  
  18. ?>
  19.  
  20. <p><b><font size="+1">AmigaPlus News Admin</font></b></p>
  21. <table width="100%" border="0" cellspacing="0" cellpadding="2">
  22.   <tr>
  23.     <td bgcolor="#0099FF"><b>News hinzufügen</b></td>
  24.   </tr>
  25.   <tr>
  26.     <td>
  27.       <form name="add_news" method="post" action="add_news.php">
  28.         <table width="100%" border="0" cellspacing="0" cellpadding="0">
  29.           <tr> 
  30.             <td width="150" valign="top"> 
  31.               <div align="left">Überschrift</div>
  32.             </td>
  33.             <td> 
  34.               <input type="text" name="title" size="50" maxlength="200">
  35.             </td>
  36.           </tr>
  37.           <tr> 
  38.             <td width="150" valign="top"> 
  39.               <div align="left">
  40.                 <p>Newstext</p>
  41.                 <p><font size="-1">Zeilenumbrüche nur machen wenn auch wirklich 
  42.                   ein Absatz erscheinen soll in den News.</font></p>
  43.               </div>
  44.             </td>
  45.             <td> 
  46.               <textarea name="newstext" cols="70" rows="10" wrap="VIRTUAL"></textarea>
  47.             </td>
  48.           </tr>
  49.           <tr> 
  50.             <td width="150" valign="top"> 
  51.               <div align="left">Link</div>
  52.             </td>
  53.             <td> 
  54.               <input type="text" name="link" size="50" maxlength="200">
  55.             </td>
  56.           </tr>
  57.           <tr> 
  58.             <td width="150" valign="top"> 
  59.               <div align="left">Quelle</div>
  60.             </td>
  61.             <td> 
  62.               <input type="text" name="source" size="50" maxlength="100">
  63.             </td>
  64.           </tr>
  65.           <tr> 
  66.             <td width="150" valign="top"> 
  67.               <div align="left">Autor</div>
  68.             </td>
  69.             <td> 
  70.               <select name="author">
  71.               <?php
  72.                 $query = "select * from amigaplusnews_authors order by short_name asc";
  73.                 $query_result = mysql_query($query,$dbwww);
  74.                 while($row = mysql_fetch_array($query_result))
  75.                 {
  76.                     ?>
  77.                     <option value="<?php echo $row["id"] ?>"><?php echo $row["short_name"]." - ".$row["full_name"]; ?></option> 
  78.                     <?php
  79.                 }
  80.               ?>
  81.               </select>
  82.             </td>
  83.           </tr>
  84.           <tr> 
  85.             <td width="150" valign="top"> 
  86.               <div align="left">Kategorie</div>
  87.             </td>
  88.             <td> 
  89.               <select name="category">
  90.               <?php
  91.                 $query = "select * from amigaplusnews_categories order by name asc";
  92.                 $query_result = mysql_query($query,$dbwww);
  93.                 while($row = mysql_fetch_array($query_result))
  94.                 {
  95.                     ?>
  96.                     <option value="<?php echo $row["id"] ?>"><?php echo $row["name"] ?></option> 
  97.                     <?php
  98.                 }
  99.               ?>
  100.               </select>
  101.             </td>
  102.           </tr>
  103.           <tr> 
  104.             <td width="150" valign="top"> 
  105.               <div align="left">Zielframe/fenster</div>
  106.             </td>
  107.             <td> 
  108.               <input type="text" name="target" value="_blank" maxlength="100">
  109.             </td>
  110.           </tr>
  111.         </table>
  112.         <input type="submit" name="submit" value="speichern">
  113.       </form>
  114.     </td>
  115.   </tr>
  116. </table>
  117. <br>
  118. <table width="100%" border="0" cellspacing="0" cellpadding="2">
  119.   <tr> 
  120.     <td bgcolor="#0099FF"><b>News ändern</b></td>
  121.   </tr>
  122.   <tr> 
  123.     <td>
  124.       <form name="change_news" method="post" action="change_news.php">
  125.         <select name="newsentry">
  126.         <?php
  127.                 $query = "select * from amigaplusnews_content where visible = 1 order by timestamp desc";
  128.                 $query_result = mysql_query($query,$dbwww);
  129.                 while($row = mysql_fetch_array($query_result))
  130.                 {
  131.                     ?>
  132.                     <option value="<?php echo $row["id"] ?>"><?php echo $row["title"] ?></option> 
  133.                     <?php
  134.                 }
  135.         ?>
  136.         </select>
  137.         <br>
  138.         <input type="submit" name="submit" value="ändern">
  139.       </form>
  140.     </td>
  141.   </tr>
  142. </table>
  143. <br>
  144. <table width="100%" border="0" cellspacing="0" cellpadding="2">
  145.   <tr> 
  146.     <td bgcolor="#0099FF"><b>News löschen</b></td>
  147.   </tr>
  148.   <tr> 
  149.     <td> 
  150.       <form name="delete_news" method="post" action="delete_news.php">
  151.         <select name="newsentry">
  152.                 <?php
  153.                 $query = "select * from amigaplusnews_content where visible =  1 order by timestamp desc";
  154.                 $query_result = mysql_query($query,$dbwww);
  155.                 while($row = mysql_fetch_array($query_result))
  156.                 {
  157.                     ?>
  158.                     <option value="<?php echo $row["id"] ?>"><?php echo $row["title"] ?></option> 
  159.                     <?php
  160.                 }
  161.         ?>
  162.         </select>
  163.         <br>
  164.         <input type="submit" name="submit" value="löschen">
  165.       </form>
  166.     </td>
  167.   </tr>
  168. </table>
  169. <br>
  170. <table width="100%" border="0" cellspacing="0" cellpadding="2">
  171.   <tr> 
  172.     <td bgcolor="#0099FF"><b>Autor hinzufügen </b><font size="-1">(ohne die 
  173.       eckigen Klammern)</font></td>
  174.   </tr>
  175.   <tr> 
  176.     <td> 
  177.       <form name="add_author" method="post" action="add_author.php">
  178.         <p>Kurzform: [ 
  179.           <input type="text" name="short_name" maxlength="10">
  180.           ]<br>
  181.           Voller Name: 
  182.           <input type="text" name="full_name" maxlength="100" size="30">
  183.           <br>
  184.           <input type="submit" name="submit" value="speichern">
  185.         </p>
  186.       </form>
  187.     </td>
  188.   </tr>
  189. </table>
  190. <br>
  191. <table width="100%" border="0" cellspacing="0" cellpadding="2">
  192.   <tr> 
  193.     <td bgcolor="#0099FF"><b>Autor ändern</b></td>
  194.   </tr>
  195.   <tr> 
  196.     <td>
  197.       <form name="change_author" method="post" action="change_author.php">
  198.         <select name="authorentry">
  199.         <?php
  200.                 $query = "select * from amigaplusnews_authors order by short_name asc";
  201.                 $query_result = mysql_query($query,$dbwww);
  202.                 while($row = mysql_fetch_array($query_result))
  203.                 {
  204.                     ?>
  205.                     <option value="<?php echo $row["id"] ?>"><?php echo $row["short_name"]." - ".$row["full_name"]; ?></option> 
  206.                     <?php
  207.                 }
  208.         ?>
  209.         </select>
  210.         <br>
  211.         <input type="submit" name="submit" value="ändern">
  212.       </form>
  213.     </td>
  214.   </tr>
  215. </table>
  216. <p> </p>
  217. </body>
  218. </html>
  219.